Entity DefinitionLogical Name : KeyCustomer |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| CustomerID (FK)(PK) | A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. | ID_CT | Identity | integer | Customer(PA_CT) |
| PrivacyOptOutCode | A two character retailer assigned code denoting which forms of contact the Customer has chosen to opt out of. | CD_PVCY_OOUT | Code2 | char(2) | |
| ConsumerRegistrationStateID (FK) | Token ID for an instance of a ConsumerRegistrationState. | ID_CNS_RGSTN_ST | Identity | integer | ConsumerRegistrationState(CO_CNS_RGSTN_ST) |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| Customer | may be a | KeyCustomer |
| ConsumerRegistrationState | captures registration of | KeyCustomer |
| KeyCustomer | is classified by | KeyOrganizationCustomerCompositeSegment |
| KeyCustomer | is a member of | CustomerAffiliation |
| KeyCustomer | spends | ExternalPurchasedCreditDebitCardSpendData |
| KeyCustomer | is characterized by | KeyCustomerAttributeValue |
| KeyCustomer | is characterized by | KeyIndividualCustomerCompositeSegment |
| KeyCustomer | purchases through | CustomerAccount |
| KeyCustomer | has | WalletShareEstimate |
| KeyCustomer | uses | KeyCustomerGeographicSegment |
| KeyCustomer | refers | CustomerReferral |